Excel Measurable Goals
* MS = Microsoft

NOTES: Teacher should modify the following goals to be appropriate for the student/client. At the bottom of this page is a link titled "BACK" that you take you to the "Excel Lessons" web page.

Given instruction and MS Excel, ____ will open the program, 5 out of 5 times.

Given instruction and MS Excel, ____ will use Alt h i s to insert a new "Sheet" into and Excel Workbook, 10 out of 10 times.

Given instruction and MS Excel, ____ will  Alt h o r to rename a "Sheet" in an Excel Workbook, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Page Up or Control Page Down to move from Sheet to Sheet in an Excel Workbook, 10 out of 10 times.

Given instruction and MS Excel, ____ will use right and left arrow keys to move to a designated cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use down and up arrow keys to move to a designated row, 10 out of 10 times.

Given instruction and MS Excel, ____ will use the Control g (goto command) to move to a designated cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use the Control f (find command) to find a specified number or word on the spreadsheet, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Home key combination to move directly to cell a1, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control and arrow key to move from one data/text region to another, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift 1 to change a cell to two decimal places, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift 2 to insert the time in a cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift 3 to insert the date in a cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift 4 to change a cell to currency ($), 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift 5 to change a cell to percent (%), 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control semi-colon (;) to insert todays date in a cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control Shift semi-colon to insert the current time in a cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use the Alt h m key command sequence and menu to merge cells, 10 out of 10 times.

Given instruction and MS Excel, ____ will use the Alt  h o key command sequence and menu to change the width of a column, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Control1 to bring up the "Format Cells" dialogue box, 10 out of 10 times.

Given instruction and MS Excel, ____ will right arrow through the tabs "Number Alignment Font Border Fill Protection" of the "Format Cells" dialogue box, 10 out of 10 times.

Given instruction and MS Excel, ____ will use hit the Tab key to move through the areas of a designated tab of the "Format Cells" dialogue box, 10 out of 10 times.

Given instruction and MS Excel, ____ will use the "Format Cells" dialogue box to alter a cell to teacher specifications, 10 out of 10 times.

Given instruction and MS Excel, ____ will type "=" (without the quotes) to start a formula, 10 out of 10 times.

Given instruction and MS Excel, ____ will type simple addition formulas, 10 out of 10 times.

Given instruction and MS Excel, ____ will type simple subtraction formulas, 10 out of 10 times.

Given instruction and MS Excel, ____ will type simple multiplication formulas, 10 out of 10 times.

Given instruction and MS Excel, ____ will type simple division formulas, 10 out of 10 times.

Given instruction and MS Excel, ____ will type the SUM function, 10 out of 10 times.  ex. =sum(a1:a29)

Given instruction and MS Excel, ____ will press Alt = to Auto Sum a range of cells, 10 out of 10 times.

Given instruction and MS Excel, ____ will type the AVERAGE function, 10 out of 10 times.  ex. =average(a1:a29)

Given instruction and MS Excel, ____ will explore the "templates" by moving to File then New, or in Excel 2013, opening the Excel program, 10 out of 10 times.

Given instruction and MS Excel, ____ will press Control c to copy a cell (formula), 10 out of 10 times.

Given instruction and MS Excel, ____ will press Control v to paste the contents (formula, data or text) into a new blank cell, 10 out of 10 times.

Given instruction and MS Excel, ____ will use Shift and arrow keys to highlight a range of cells, 10 out of 10 times.

Given instruction and MS Excel, ____ will press Control v to paste a copied formula, text or data into highlighted cells, 10 out of 10 times.

Given instruction and MS Excel, ____ will research and use screen reader hot keys for Excel, 100% of the time.

BACK